package cn.iune.erp.inventory;


import java.sql.SQLException;
import java.util.List;

import com.alibaba.fastjson.JSONObject;

public interface IFileItemDao {
	
	public void insert(FileItem obj);
	
	public void delete(String fID);
	
	public FileItem update(FileItem obj);

	public List<FileItem> getAll();
	
	public FileItem getByID(String fID);
	
//	public FileItem getByNo(String itemNo, String enterpriseNo);

//	public FileItem getByName(String itemName, String enterpriseNo);

	FileItem getByNo(String itemNo, String enterpriseNo);

	FileItem getByProperty(String groupID, String itemProperty);

	List<FileItem> getSKUList(String fID);

	String getMaxSortNoPlus(String enterpriseNo);

	void deleteSKU(String fParent);

	FileItem getByBarcode(String barcode, String enterpriseNo);

//	void delete(String fID, String userId);

	JSONObject query(JSONObject data) throws SQLException;

	FileItem getByName(String itemName, String itemProperty, String enterpriseNo);

	List<FileItem> getRootItemList(String enterpriseNo, Integer offset, Integer limit);

	List<FileItem> getLeafItemList(String enterpriseNo, Integer offset, Integer limit);

	JSONObject querySimple(JSONObject data) throws SQLException;

	JSONObject create(JSONObject data);

	List<FileItem> getList(String enterpriseNo);

	List<FileItem> getListByLevelCode(String levelCode, String enterpriseNo);

	List<FileItem> getProductList(String enterpriseNo);

	List<FileItem> filterByNo(String likeNo, String enterpriseNo);


}
